SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589943 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589943 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919575,368813,964813,604493,898294,66917,801507,143136,486255,597962,241232,154871,444285,512189,942158,744279,733141,146276,734521,251883,951481,879970,290200,1043701,504643,40503,977741,58518,648238,932829,739402,661210,795755,892817,938367,255747,634600,208786,911667,232853,2791,440103,288557,257070,95570,18079,961026,226456,759352,117063,65165,741291,592491,650519,18845,236644,252965,812663,526485,699593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]