SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 126080 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 126080 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502414,481627,352941,925267,498785,1009810,571569,845831,938433,1005206,476389,113353,682777,100102,269654,706361,578328,159717,66851,270843,444283,163897,495552,417696,871463,1048352,929954,915900,605202,1017093,486160,76012,184221,641100,136771,960445,107666,979003,152005,411509,477968,243557,358113,661482,910194,706893,145904,777190,390593,58400,1015956,543981,204918,526945,740111,750137,1036481,706624,961224,152685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 126080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 126080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]