SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315029 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315029 [ RunTime:0.002565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648685,698069,148134,331005,480097,734328,1029538,486948,210255,617831,184649,204055,43217,135720,104913,579585,856401,114822,859966,156286,832176,859589,71753,396130,170146,1016499,373238,875820,142108,134524,725951,286460,9818,855960,523015,768867,727740,838715,671310,805992,915096,1042240,954910,885523,896427,522297,633350,125859,35985,353029,163827,829686,261093,920462,581366,232761,1043376,932384,920799,8218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]