SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501868 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501868 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727704,869963,94631,1040170,843012,301218,710619,316226,962237,187340,110368,133535,775665,811363,826300,756962,92295,432823,77181,299310,512796,1034844,125524,75309,834647,643395,281858,42755,329701,657710,974655,725643,393492,881669,447068,541025,1006147,660779,536179,870583,843912,392434,985260,795112,286979,38003,695098,443799,244210,1030485,519681,649316,506763,135917,185219,894634,33875,714351,980375,431800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001757s ]