SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681199 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681199 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962942,566335,870789,757229,368511,774665,518405,525308,385373,593469,192968,129659,300006,106051,170358,136273,400783,755386,987787,1038077,878781,410681,789831,858394,54319,936403,89662,875090,272373,316334,154763,672418,938543,200025,150335,675450,122894,83608,970337,621370,192083,322962,391039,907649,487429,585924,593119,445476,739239,702977,182916,957350,133902,18172,968192,601884,103210,996211,1012879,457746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]