SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426020 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426020 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34442,788063,588197,727192,229401,52689,216921,586276,154895,184,457553,128608,767752,288730,277273,981939,752671,339976,1004921,221553,49872,867045,287753,596985,523470,973348,678990,31262,963965,445116,761264,1009530,1005285,325837,65938,139592,229731,297402,660753,979882,582254,300970,134337,177535,581887,512521,239756,757515,801311,594763,666012,229562,1039199,879596,49963,609827,754701,558215,783992,115209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]