SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285005 LIMIT 1 [ RunTime:0.000663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285005 [ RunTime:0.003834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032892,38143,119533,333745,128572,347136,262023,498486,677496,520902,395127,334132,1046514,943480,545366,629734,374423,600911,1018681,686019,455790,599834,933171,378326,147018,76089,615576,58907,941660,638699,943670,82439,17964,188160,1025329,619025,514856,120270,847295,992876,192354,741894,400886,182591,729447,510063,307071,522043,613295,926057,824093,976169,941506,26753,858112,1004971,121292,733424,1020586,390824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000879s ]