SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549615 LIMIT 1 [ RunTime:0.000898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549615 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509905,148769,685411,974596,397722,734530,550096,693306,646708,193415,900002,280391,455296,96689,498335,683535,869216,100145,124870,379763,160541,148639,1042994,499056,641794,1023097,153825,626360,661452,393834,929891,194819,76123,366863,77024,897620,636181,604674,208129,657293,482477,780735,247252,701329,283101,988054,683399,609081,452606,848636,656439,771384,675869,1011030,454502,708046,50067,670686,811120,91801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001133s ]