SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440141 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440141 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877023,681943,974640,779653,371808,435729,120046,614988,463148,123344,3364,922242,784604,955519,1044475,429040,429158,535103,193570,191040,171395,1033890,143326,586148,206960,276969,772128,920867,503366,97376,1010545,591867,688988,934554,731510,413281,29417,50680,720199,424893,373805,553966,190324,445293,211040,338479,876492,432718,955907,302701,95363,158285,734646,868582,294677,618470,724203,1033126,553492,734387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]