SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537875 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537875 [ RunTime:0.003872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535538,308990,517389,333640,823631,179683,1036283,738871,481739,911412,316190,279015,669127,1038859,458397,490783,108744,651310,543171,848981,1044747,281897,801486,646144,190923,104669,723429,607101,125287,76472,712683,390455,566721,730045,7213,92009,107037,823536,784798,535871,793301,492415,771401,182887,3862,549715,501758,66457,861872,351381,324360,808644,988532,601212,234513,604520,92751,831777,45989,822594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]