SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731043 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731043 [ RunTime:0.004032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208592,63768,910316,291801,126995,758693,460574,308871,353621,4032,880876,500424,980219,237802,9086,939649,79858,759144,1034330,687382,958355,95291,453019,989580,118201,570689,476940,638690,885452,297207,329663,1000125,962933,137372,886900,303228,682670,511237,687449,1006883,252089,742680,153334,291199,350797,668115,622690,651611,5602,889354,302850,310314,584029,984969,943618,198587,458436,956967,534123,609532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]