SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445791 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445791 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317841,832105,381378,689380,237737,36563,1030166,366212,777806,894490,998322,86852,182738,643717,57968,1041030,836383,14560,605472,30839,904412,927287,329868,459944,578810,71059,269956,1043982,995098,388186,100495,162504,65400,591707,830709,251742,270742,1038189,362279,293534,205912,206073,161532,615177,23845,572527,374884,375681,698673,673137,212775,10978,154126,483511,1044948,871573,783088,138946,917986,403636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]