SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419004 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419004 [ RunTime:0.004239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908386,170086,825938,588282,662335,525457,500986,745455,1045359,33432,1005783,316909,276909,1011482,972579,783897,400761,922568,815917,627516,928558,541690,55312,869687,682777,995265,72176,583937,529700,411237,196743,684970,773792,579768,763155,168337,719508,846151,345870,392151,826587,477362,821696,1016184,272287,244022,396475,427374,447422,39194,20144,120231,603692,610204,144312,708148,404869,609631,1002217,858951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]