SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556974 LIMIT 1 [ RunTime:0.002008s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556974 [ RunTime:0.002873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508539,55485,47249,165211,49055,850058,481823,1037458,726341,155752,636224,1042276,383766,793045,899788,203917,738153,23556,253486,966684,559846,1048034,687041,851283,237784,717397,490084,739908,859043,1044369,20119,479226,763140,622277,536047,883851,1005609,849041,315987,939643,619823,257082,688991,117836,399287,168281,243783,1005793,428498,782590,901567,809249,1001285,883765,614326,771945,1001058,98476,505377,218017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]