SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445070 LIMIT 1 [ RunTime:0.003367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445070 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328399,427446,785193,664770,352127,282413,435309,930976,879842,1032820,442023,1870,329700,399694,868842,922332,672207,1039792,12995,675173,273301,178941,678369,634655,248936,17094,307730,268276,158110,99190,132964,316063,43658,65851,165669,817711,672074,243463,746605,967255,870010,1028608,103727,902574,966926,461370,848332,336563,1032313,626929,781450,147775,441494,266186,1002514,776004,1002526,244402,682993,109049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]