SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042571 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042571 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584537,180379,1036219,152275,910992,75711,163898,724778,1035273,1010071,394801,736268,581074,594940,614513,927225,192648,428079,715550,862546,526338,73236,242262,137831,296146,935464,122326,603351,870394,936258,503580,685560,877922,651667,486749,735891,353177,450967,831105,916995,513288,193041,12661,696806,593630,726862,59190,198865,438470,603691,105624,565836,555080,544573,81249,219198,203181,285596,553978,636129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]