SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399745 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399745 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404137,391760,440683,939516,776782,638413,398377,487203,20039,1011971,531828,142619,249734,271702,611891,1020995,512909,430680,510500,182664,1000470,34709,7141,659389,724834,76932,314410,3713,198382,738125,1024685,269547,469621,306595,457058,760741,898909,931990,637232,174414,329840,871775,29966,497070,58277,435999,192504,926692,678165,339279,16652,815199,740035,536278,756659,351865,437128,805229,221468,632877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399745 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399745 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]