SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022258 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022258 [ RunTime:0.002997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604939,342770,202493,467833,272580,495141,355842,101255,400026,633543,140293,610527,687581,420553,259258,537816,32825,211117,424436,202166,524177,867212,880437,607969,306586,406610,264080,950357,748974,19858,511885,182858,944000,480147,300275,735096,37726,423994,770711,236685,242467,741202,320085,720378,366444,683128,867987,612290,940243,80355,1042370,836726,43489,873762,32389,894236,815388,265810,113684,964050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]