SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423390 LIMIT 1 [ RunTime:0.002255s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423390 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75678,654750,140258,1040189,124371,791305,497713,609724,955885,762234,588497,548909,627337,804035,1037994,413871,723464,997537,744455,991757,489244,873321,341063,60266,766849,209812,679942,20813,698421,266479,705233,340756,545323,287993,913173,437826,429564,305451,233509,95905,110560,524860,274287,282618,888342,868925,284609,163758,704474,30134,928395,104001,264533,318856,758095,973888,929172,326690,882823,757733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]