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` = 430035 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430035 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780188,341903,32136,1024037,489480,66859,304887,691837,296657,679311,1028172,368701,35049,815618,561045,439696,623378,343019,680428,864596,991327,236554,414080,1030518,372694,983294,620934,12941,34635,910221,667432,518516,873627,358657,228906,5333,597960,553997,436483,229543,250037,365297,402877,227708,259210,672814,983432,848917,654987,1018034,389625,346709,321958,203721,367778,82687,993929,308743,638884,634390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]