SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420901 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420901 [ RunTime:0.001427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388009,93951,430941,544737,259894,581342,897997,378298,547859,688640,330725,644520,294091,638601,691121,161782,592881,262555,947457,978462,720170,557282,9838,503959,16973,164399,591418,770219,38910,253089,146154,738727,312123,490659,149307,310547,208639,768283,622460,78233,396250,768108,1019087,252722,381540,494357,595709,96794,27031,459333,964004,494323,342428,747341,489839,999457,941623,987747,406906,504591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]