SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012226 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012226 [ RunTime:0.003170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466383,673900,356191,795386,340391,834227,89001,1027731,993737,560020,686871,1022998,458756,326837,756237,883708,308527,952436,849996,527806,574239,17720,37148,147455,34909,958317,610330,162925,423143,866960,551866,599883,59775,837257,228197,579446,558374,688660,384178,1001797,107799,676147,693553,141206,406198,793998,786081,466139,405297,1014200,738846,765966,701243,480888,138875,609308,938225,959579,464227,573053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002727s ]