SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474421 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474421 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237885,18511,305633,325290,643085,180607,215535,122310,760690,919092,968103,805663,842416,719817,650495,114888,245620,818664,1001370,653596,684177,209618,1005201,891678,800150,162573,461488,132734,1033831,817888,921446,612942,459978,686539,455724,669187,825582,186130,259194,1000752,103703,951183,494248,947701,580715,312432,296734,639190,569787,848928,776470,590054,952628,191000,989894,676884,849197,461296,141554,152292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]