SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042203 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042203 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688051,519658,94236,716973,881950,993584,730032,607164,587002,569588,657576,439905,523182,623671,493348,385996,45679,218973,709476,660197,283611,125550,614149,19586,499798,868529,168460,795269,959651,743782,274252,235202,212326,68657,6705,842516,449415,108013,890310,449816,246421,419391,7660,226818,929896,474281,195845,463057,291871,711211,115319,59376,759428,346067,265966,38991,609574,505253,579037,972348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]