SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528911 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528911 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009415,955927,75975,398248,252766,763670,148011,103780,930663,476259,811566,593927,235742,246135,706752,618008,1048105,60511,342877,144363,290764,611570,119740,348349,161126,661075,9192,159751,374949,442279,814414,563519,710324,536620,911787,808902,848647,302690,641398,206226,429964,839446,31923,785363,707809,585449,415665,689049,249508,534975,974388,726983,47727,19248,472715,547680,255593,491267,430079,30751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001777s ]