SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134111 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134111 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63219,719324,849426,601782,1021940,410781,141966,13680,105173,894032,744181,456866,966834,125005,1015240,829689,263119,890645,912341,612685,619853,533573,809535,275887,142771,268602,825620,816501,728150,45178,932817,550290,155512,761120,297766,9521,511955,329589,145536,787978,256071,588692,381578,555642,390587,373857,677403,811764,367168,277168,833853,381229,826773,1022681,464624,549161,498532,189360,35479,527106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]