SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572008 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572008 [ RunTime:0.004360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415885,363245,954213,562964,977520,283834,275616,163196,662920,411599,377961,794511,915492,33532,140691,122412,635771,974599,652950,545480,570025,79651,652446,274480,529153,344778,953485,163071,193392,930280,402150,476196,376800,986127,360700,706996,524690,183840,770932,775884,385366,323418,796167,406817,908112,785022,740544,738837,756917,214290,162810,837637,733755,933617,130878,448213,712040,417433,758824,979603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]