SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525148 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525148 [ RunTime:0.003776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817279,569552,580664,277216,814895,701763,673917,195860,277950,762227,120389,1042919,496444,995280,391745,202905,1031634,607441,666874,851705,664124,173685,827167,732685,152495,820054,55385,493289,1038615,1003197,521271,171294,573980,501047,79089,685146,415395,94462,992793,489180,385413,902196,404918,572023,430881,324603,885573,972238,299939,323622,435536,110497,1042842,811446,451497,472307,653384,1032474,377175,854666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003745s ]