SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030810 LIMIT 1 [ RunTime:0.003706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030810 [ RunTime:0.006863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612047,3480,594450,452676,434046,724376,503535,168885,169922,191460,1004030,1015032,431780,760669,328090,385777,469393,534467,974514,727691,687999,991340,68665,319368,187024,304306,982407,515714,716410,826612,582651,651978,708695,391745,744135,173389,974721,403835,543847,173777,741672,146296,122973,891529,625966,707585,401341,967275,162746,1005555,109335,99478,82013,875905,1045182,511195,576074,1004832,800803,730042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006979s ]