SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567021 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567021 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986205,469088,53110,850601,853594,751451,693768,598847,153421,760891,550832,770198,67391,76256,604391,225728,597661,577143,518592,279519,453940,92370,710494,341525,973478,69094,568510,109590,87857,739423,227568,897113,769389,213469,78329,949821,494093,510753,61928,138784,249831,523498,946159,1027389,679323,49088,419239,391489,811792,479151,358262,821919,979617,169341,442352,766748,195299,1010196,785915,143239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]