SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442346 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442346 [ RunTime:0.001353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940229,570228,562904,171684,965677,406609,238016,282563,744893,299581,314832,259790,300653,1004035,212170,812735,38778,966626,71051,820415,53455,321321,321821,545344,766827,864598,145708,257703,960803,163540,226149,450679,801860,938784,495922,1037571,406374,1034245,313284,1048714,342828,123508,702541,300796,911543,512242,183299,440379,684023,65220,140886,787154,6968,160838,781809,886225,656962,92297,63633,817527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]