SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270060 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270060 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658825,406370,278498,390694,475983,131025,234809,382703,697471,964504,248548,746311,162511,321869,373392,889490,900932,961207,879023,855565,822425,790259,668570,673335,342628,64838,754925,388532,1029378,1038092,693645,621513,892506,1011428,607083,487570,633573,568011,451877,61377,46882,975234,677394,729849,71150,28940,98287,235406,901773,481044,253185,362388,298636,604226,83180,660052,792951,324362,522234,843386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]