SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463814 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463814 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764099,406743,747606,445277,468836,485766,170738,612790,586648,232783,87209,429882,15151,1030250,423893,451669,229154,1019663,1020111,408221,437992,429437,785344,952936,212638,790209,612580,432190,757048,588584,731953,259494,812649,644654,407839,908278,260209,394806,579563,850021,15074,625677,243964,619457,623978,793483,608886,421918,862282,766059,1031099,610222,130417,498064,749482,507849,581119,1015321,923566,371672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]