SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536961 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536961 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431541,433400,934002,378986,195451,543826,155868,882201,599009,578225,489797,214840,195758,549954,509418,593435,281352,324493,1031808,69614,685123,281084,293964,44733,592015,45254,619680,423624,1008821,361378,257546,793580,936146,913918,4111,395141,316480,601160,731277,736234,513380,534674,115867,132435,205969,55969,965630,285069,195810,1029274,619487,622279,782157,468663,281406,190401,561279,1018386,119761,612541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]