SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589853 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589853 [ RunTime:0.004007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530053,628901,162224,998703,619606,14916,807813,231058,325981,162378,476988,428352,519756,264121,868903,605656,692881,126729,397745,294680,247038,1043753,127988,725240,1046735,556420,158293,715278,521070,115067,565571,620083,58442,842602,242730,447321,692379,537430,476234,927479,454525,322699,33910,833724,354583,565500,1004430,566453,23243,372958,921613,593346,1037047,601990,41018,723524,533313,828251,99155,781553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]