SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575403 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575403 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826530,685451,351409,64728,37765,348647,854151,413491,1019218,54648,4920,601121,357735,374321,429812,191861,660510,1026178,146476,361194,110256,962520,385172,509719,890962,802159,578702,542244,294696,581554,690631,655747,54859,421772,675457,1016704,295881,343300,467826,152923,221521,701852,778590,261669,760645,539403,205276,1048409,934411,940763,302496,755827,285439,142029,710330,714920,995812,509492,1029690,346122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]