SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840169 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840169 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517911,466899,272305,905690,74198,238819,826694,926134,509455,1040149,404747,771255,428476,421941,358475,807062,879767,245497,339097,887234,1023369,9103,1033582,789394,368490,211317,785631,775241,610464,147318,115669,771372,935372,299220,355924,48869,521739,613081,637280,118443,488281,208262,398823,289432,243710,679447,5039,302082,1007964,196071,96716,927694,360986,324129,446262,873519,619923,645968,18546,640186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]