SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564309 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564309 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838723,776624,88987,845441,654099,101964,406002,6029,858071,444967,189607,1032223,1012375,188887,696034,1044627,865440,551712,506578,802825,906840,1033655,421135,974218,628596,423861,66080,510194,641133,831915,844101,874966,32449,539264,131272,386535,332297,99540,261508,185138,1021092,255047,507306,1021560,646008,973817,114630,652991,255072,79728,625358,338040,722916,78799,99361,943194,494609,815508,692864,405683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]