SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205878 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205878 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040715,588993,294132,207361,1003322,636395,589647,365320,449955,522370,531999,146116,538524,580557,798514,12637,131108,136713,163830,610447,403073,306891,879827,429865,60561,862011,929600,975799,567120,590863,1010213,1003514,650714,105495,936342,61103,178028,657248,734760,1012108,172871,609849,683094,2175,374995,315676,21086,767869,585236,555643,780965,288567,934106,276986,659783,216434,135913,913076,748741,538565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]