SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668176 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668176 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026554,161803,607754,1048868,461560,104305,39724,619473,1031838,389161,1016419,585742,142144,52451,710105,244576,859027,671883,222636,343626,112004,484256,1019811,159037,738424,797370,710795,571472,821844,269976,206579,227795,490655,38004,704773,115058,750135,349169,28826,539249,131862,658655,514407,708079,542709,103847,848364,691498,187667,166493,501754,76000,315800,427277,524695,424825,250006,774541,905961,638019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]