SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516909 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516909 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960132,1038355,553282,185163,658961,771535,903715,663871,161153,989991,933675,414056,602227,226252,423121,127679,106523,890270,174149,1023392,812788,696566,55364,964864,64802,544964,244649,237329,462685,19293,226362,1037892,981452,350294,932013,601586,388503,38396,280428,374063,984471,566073,327113,432834,392365,150445,648800,54866,438473,362336,530002,494960,651621,291473,394793,995162,750479,947843,1047359,909491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]