SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565917 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565917 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603556,702925,965351,533570,139939,648320,345890,318682,473702,492103,132825,131066,660358,391562,1018669,605503,335395,225026,226025,642424,85360,350373,543900,875955,72158,411993,786691,2526,804395,645737,6215,746855,380466,573482,912029,359041,866986,990778,270559,1012733,528993,27992,116091,834250,754776,248161,761986,373050,775888,1019313,626531,290755,145123,404665,854812,439708,496078,544063,328288,602337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]