SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424743 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424743 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118512,155213,2328,457982,281348,327728,430214,22624,641893,706442,434681,348389,565877,934845,853357,62806,200142,416593,93097,22747,896002,257589,167536,417455,941543,380986,823153,706076,241803,429313,999649,684083,825614,653385,929473,670488,433612,760704,928659,1021178,388319,131984,843196,781569,618325,536675,368895,543326,556765,520276,187895,419382,143708,921715,572679,995944,474633,781944,492629,60509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]