SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587894 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587894 [ RunTime:0.004520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179642,644521,171004,657647,913853,789309,176421,223125,415401,585784,279576,353805,284557,310936,219048,343321,867792,554037,909816,590286,185828,785444,987687,446017,550658,69352,790395,590932,977855,1002985,648467,781806,981119,448775,209905,992064,979752,508166,202811,128946,985047,294815,1004111,921447,554499,134124,513494,551687,755916,952887,572927,272512,557580,4607,670925,640920,178989,118880,475254,965274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000889s ]