SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423474 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423474 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912421,424063,344311,875167,145144,341375,718349,344818,146267,503380,200185,914817,751265,929637,500713,989932,899920,1238,812876,531274,590661,208089,121025,901225,1006918,23675,150241,162960,237661,341543,979667,279890,252283,975451,958089,615940,592895,849557,608244,107215,588022,965991,189743,108670,224707,340783,536384,1009782,19913,338389,411025,66885,442889,859625,339503,258765,301299,178254,73957,536957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]