SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809554 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809554 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275147,213676,271633,136710,1038764,182820,171571,857431,921851,558218,903162,76114,652235,1010981,392519,631307,141121,327664,661819,971522,357904,114587,790233,769587,499154,346305,1031438,299147,30418,854591,164547,444742,439198,580759,717328,154918,407541,173432,785209,461524,452788,416051,685575,817600,515940,990603,29772,149615,913274,385135,414597,223300,769330,434721,603972,104985,882351,752291,668998,689631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]