SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403630 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403630 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89645,302676,470804,70569,394662,237879,122327,1037226,47668,28838,305952,752630,926408,724390,738139,423554,532702,110203,880498,148407,324600,973210,388388,566286,1019382,611844,929213,108671,1043501,414838,836750,472158,684464,164811,882152,590704,1033581,125529,733807,948639,147858,145510,685131,822061,477482,245078,235791,274967,607805,476744,658837,556963,343956,193017,650711,417892,645386,964840,280540,993209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]