SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046793 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046793 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013158,510091,814145,292938,93399,203748,682381,20971,199363,388119,144109,136912,86813,658567,1000934,702414,105514,162281,409550,980146,134055,690704,461538,7004,249107,260937,119226,634934,793270,486560,897644,104381,378729,671881,500383,289577,984976,298634,740525,24202,35676,665883,672202,73311,1040866,101535,811787,163414,37996,662077,379543,184271,465802,92904,650579,260307,491922,580584,457626,289317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]