SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537191 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537191 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475112,135378,802923,812188,997331,556536,399930,68874,871589,768079,37665,422407,949016,821661,970669,442232,37718,325776,218046,326295,978996,698387,82150,506722,148139,904526,821835,891462,315862,368798,193089,458019,630963,87856,450203,121102,239680,105877,797048,38139,744982,779936,327416,74133,332887,720945,542852,29893,480797,384765,879938,691667,1036324,409890,52962,1039216,252092,204473,1019983,144388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]