SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47188 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47188 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529096,521104,1005509,593211,556831,23366,888856,826697,521021,238437,699432,656819,281305,1033150,971456,518255,277183,712205,983426,225139,41808,130598,57347,300939,642323,805743,736959,687903,478695,658062,1045962,595642,106174,738251,793949,888359,275043,631114,674831,1013638,517887,29662,715931,942423,687292,108672,585191,169045,80583,724281,122494,847545,47351,351046,580342,991836,65090,103639,378313,467052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001458s ]