SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 950599 LIMIT 1 [ RunTime:0.003386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 950599 [ RunTime:0.004777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405830,917070,791084,211153,402985,767337,336236,416446,825243,104602,622520,468347,957922,1047774,966080,591300,660144,16028,8578,259595,470688,205090,923429,468756,779001,485307,485409,244480,1029132,1040586,414885,544680,776974,855205,560137,173711,152233,775851,160705,318448,421270,705076,17286,889110,530529,277694,199092,487854,221064,176231,523595,665908,613223,83050,735232,954467,424102,1041916,833496,519461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 950599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 950599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001029s ]