SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506720 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506720 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570916,111355,526919,1032949,1027169,899554,983966,690997,907535,424077,965758,957346,912509,67883,113803,836861,450632,1029876,825710,935922,704266,767544,520548,656648,712500,724020,848456,653504,544414,450867,126661,752566,586577,792036,806109,1030902,989617,399778,445074,531112,630580,683092,982051,300982,138276,723947,587401,880967,899403,208374,444869,834149,8481,422428,997796,998102,692255,839579,949369,525676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]