SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405033 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405033 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182466,210285,165928,144861,550701,276971,305982,462879,594790,896142,189936,559317,1046909,764307,680052,50711,410594,86548,360520,757287,713215,267237,660240,768803,40531,819061,646129,882307,94791,519650,994608,889896,432708,231302,536504,344845,56740,107959,449325,868310,1009969,534513,222777,496353,209569,887909,932698,925988,118434,51973,547337,484844,251856,183011,355800,274060,1018588,399130,583046,371368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]