SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466095 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466095 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105585,419017,570307,45812,702541,36215,648467,661687,396640,464930,221242,899080,625497,588174,214028,863841,1007277,126452,319456,89818,504431,1032017,274715,514339,743489,938058,993440,292356,471687,58470,137610,358053,997980,828690,551842,315192,1037761,85850,423470,900387,450778,888211,62453,712706,1020208,378822,346817,469016,69086,374922,760189,856713,9252,298717,346210,742150,13118,191257,659297,68701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]