SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316023 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316023 [ RunTime:0.003265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69164,59690,219503,544086,704382,882200,329122,319984,735740,1033249,330438,819348,847737,166285,210330,292514,4575,45955,198367,746115,560029,226175,998739,455254,268900,798328,745245,785277,1029291,128411,343405,811442,190058,919438,414831,90598,797179,48411,709712,99818,230776,959491,196169,323902,183640,522797,342100,1025943,22384,998850,682780,909061,13885,966060,92133,513808,62045,836517,492324,563215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]