SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509411 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509411 [ RunTime:0.003400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71708,725159,187713,903102,260524,840334,39069,397326,882452,304977,796754,1035196,370771,430704,198277,275767,97022,567859,533168,327057,235870,347165,1009843,724266,334600,499639,242400,453310,658805,359822,828462,841895,294223,289332,888873,1017141,277808,748638,820483,145901,310441,858259,32556,12309,60570,9732,443985,242581,128400,124372,697339,909901,25006,783894,279426,95920,560743,418085,652998,260307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]