SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135043 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135043 [ RunTime:0.003554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365043,671238,264061,993244,760160,454213,545518,864729,412102,661346,109651,572009,1005913,957338,415689,642076,731198,140627,27418,1009810,893684,713302,834957,585674,591406,444674,1035001,311791,89581,645518,485739,467818,164991,227501,98578,520914,200034,621197,473920,518174,308947,21904,114963,904816,40562,850869,568006,140132,917837,106678,1028695,766366,646859,951837,731490,942051,79684,913092,677134,745776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]