SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200487 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200487 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831691,1029582,1000542,313515,859750,559469,698583,991793,88424,806710,383648,1034424,982932,318289,454168,914921,571341,672268,148579,51715,165664,364503,40535,875804,712298,164258,578311,175694,804283,835563,976203,52498,957857,492964,20203,360369,179301,587634,758759,841859,713236,385642,734610,604487,302371,642184,212606,266417,596719,582999,86684,305533,648016,390284,720657,706191,223966,204120,906097,1045400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]