SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309108 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309108 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818203,180737,708373,294420,867056,703851,672194,864254,193811,916004,517749,577411,711621,537657,288666,505132,594681,491712,63491,975726,279930,989152,413029,77524,535874,573983,306027,557666,154035,556728,962964,344806,590761,370773,500858,738180,870892,998750,590120,510736,444723,890388,194731,182546,365664,155240,210630,3393,1038961,321754,373529,709758,157819,649377,773925,123593,383218,254548,507851,721719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]