SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403260 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403260 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869068,685153,958200,34912,615092,468095,937099,1036333,629734,645561,965125,797040,698525,711120,591123,854649,561028,991766,92922,115336,498199,254101,36436,683024,946542,881483,773906,423125,680779,332272,441791,542309,231700,772029,1037282,1039079,701562,272102,738456,457110,244914,434112,572971,351118,438989,407786,467948,43758,261804,797582,990802,270876,485683,2780,734435,124171,675851,656576,875138,975163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]