SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510820 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510820 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430737,269733,757196,686402,851067,811133,371042,1038812,563723,377267,895383,1044855,213924,997998,16461,781467,211978,981267,844779,892814,116737,638502,635555,331441,601487,381897,444803,969191,460650,580075,963361,171055,386635,510653,188615,824077,59831,670649,743170,763741,796747,625224,487905,391522,638377,959604,724314,635617,959438,264320,1023503,363932,686945,167349,132310,948322,125799,410313,40156,289152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]