SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402797 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402797 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954432,814409,1039411,274925,189909,55105,1005800,940790,997382,477361,267105,369648,345330,246249,621925,156106,1030042,107698,742703,719475,505906,192455,248832,427754,19248,621196,587330,423325,810742,51372,497195,716374,996478,889596,305683,83721,621635,427175,77479,295379,416370,897494,93887,242371,770751,725510,669271,873768,323286,949194,123411,118990,249430,531364,562940,782238,374249,59830,211065,1006626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]