SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981516 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981516 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359157,539880,564704,938631,356067,535274,1007478,345572,1032112,815706,425550,551241,371058,251743,111833,877448,715608,127959,87190,251495,580383,635618,157872,921609,37286,183987,974176,532552,942998,68537,585029,182474,317667,392286,582882,1014670,367047,267934,973105,270760,985430,860138,771656,242903,575225,1390,809973,503918,703158,296669,443232,543196,885626,604217,52702,837874,18675,243673,439031,686887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]