SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54880 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54880 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21277,707445,79329,752452,83898,357812,28390,710945,705349,705507,716944,139757,572464,172504,924275,221710,525664,547618,933566,777497,737452,452783,764974,841036,965530,776750,779695,612089,370930,627948,80826,269478,14435,462669,879314,500097,946580,225542,906768,254358,521619,652753,999088,291680,739249,66654,115019,911034,14142,16520,788928,646443,761219,190505,19122,106259,433454,154778,351085,670894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]