SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549032 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549032 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713144,50519,187857,199890,979078,435657,251565,86909,519255,416017,85084,1025234,1043705,248516,662702,657520,384033,899627,811137,336330,241688,236574,594169,188802,478105,370557,389180,161397,959661,131952,301135,38771,109646,835689,296214,8354,941773,119125,746215,823463,545935,1046197,88050,663134,430449,245866,658421,165592,980576,723383,933819,1039194,227842,834747,917481,295645,709393,656346,310879,567793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000830s ]