SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 885213 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 885213 [ RunTime:0.004671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400694,767315,12775,226776,700206,19707,984409,677709,1028697,182049,1040939,886796,56533,522004,434002,974535,505177,31217,408482,575970,498249,279882,413442,439255,111481,60458,637858,50381,612268,749582,343044,273331,526746,359569,589066,329895,48323,962648,1026309,870462,766806,744254,285042,166463,635316,1001077,180750,500065,75013,896464,742490,974556,651018,416156,879332,154247,968186,807948,586257,802878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 885213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 885213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]