SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129410 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129410 [ RunTime:0.002071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36617,162044,332338,785821,782863,28340,583523,893700,716744,909104,657092,775670,990245,844076,228757,2007,414309,14904,1000236,20433,682682,781414,752231,909291,498290,775945,682942,1046035,791239,1042023,1030807,50563,190123,257648,661921,29959,8109,791557,702977,126780,465638,508865,854030,43958,459457,912868,617177,189941,118232,377966,392608,780765,140397,923453,110801,342611,447950,985253,207548,894010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]