SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018040 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018040 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698284,19938,38847,440281,675975,632757,672272,603057,830194,818975,38541,964419,991542,950693,937620,864550,831700,782985,627509,683186,57006,828658,808427,625181,841185,92795,53557,509090,18998,516465,623682,976782,258521,565613,145201,61738,1009448,496063,172293,247359,129708,47412,669329,108288,295320,1003546,709327,521887,512181,617595,586297,868383,617871,1045983,485842,789346,314545,557330,431992,56199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001664s ]